<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<%@ page import="java.sql.*" %>
<%@page import="DAO.DBCon"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>员工基本信息</title>
</head>
<style>
p.top
{
	background-color:#e6e4e4;
	border:3px solid red;
	border-radius:10px;
	margin-top:0px;
	margin-bottom:0px;
	margin-color:#e6e4e4;
}
.font{
	font-family: SimSun;
	font-weight: bold;
	font-size: 25px;
}
.button1{
	position:absolute;
	top:800px;
	left:830px;
	width: 100px;
	height: 40px;
	background-color:yellow;
	border-radius: 10px;
	font-family: SimSun;
	font-size: 15px;
	font-weight:bold;	
}
.button2{
	position:absolute;
	top:800px;
	left:1030px;
	width: 100px;
	height: 40px;
	background-color:yellow;
	border-radius: 10px;
	font-family: SimSun;
	font-size: 15px;
	font-weight:bold;	
}

body{
	background-color:#e6e4e4;
}
</style>
<body>
	<p class="top" align="center"><font size="40px" weight="bold">新员工基本信息</font></p>
	<form action="EBIChangeIn" method="post" name="ebit">
			<p class="font" align="center">姓名：
			<input style="width:200px;height:30px;" type="text" name="name"  maxlength="100">
			</p>
			<p class="font" align="center">职工号：
			<input style="width:200px;height:30px;" type="text" name="workID"  maxlength="100">
			</p>
			<p class="font" align="center">部门：
				<select name="D" size="1" style="width:100px;height:30px;">
					<% 
						DBCon dbCon = new DBCon();
						Connection conn = dbCon.getConnection();
						String sql="select * from edit91";	
					
						try{
						PreparedStatement stmt = conn.prepareStatement(sql);
						ResultSet rs = stmt.executeQuery();
						while(rs.next()){
							out.print("<option value=\""+rs.getString("Dname")+"\">");
							out.print(rs.getString("Dname")+"</option>");
						}
						rs.close();
						stmt.close();
					}catch(Exception e){
						e.printStackTrace();
					}
					%>
				</select>
			</p>
			<p class="font" align="center">职位：
				<select name="P" size="1" style="width:100px;height:30px;">
					<% 
						try{
						String sql1="select Pname from ejpt91";
						
						PreparedStatement stmt1 = conn.prepareStatement(sql1);
						ResultSet rs1 = stmt1.executeQuery();
						while(rs1.next()){
							out.print("<option value=\""+rs1.getString("Pname")+"\">");
							out.print(rs1.getString("Pname")+"</option>");
						}	
						rs1.close();
						stmt1.close();
						conn.close();
					}catch(Exception e){
						e.printStackTrace();
					}
					%>
				</select>
			</p>
			
			<p class="font" align="center">职位状态：
				<select name="PS" size="1" style="width:100px;height:30px;">
					<option value="在职">在职</option>
					<option value="转出">转出</option>
					<option value="辞退">辞退</option>
					<option value="辞职">辞职</option>
					<option value="退休">退休</option>
				</select>
			</p>
			<p class="font" align="center">性别：
			<input style="width:200px;height:30px;" name="sex"  maxlength="100">
			民族：
			<input style="width:200px;height:30px;" type="text" name="nation"  maxlength="100">
			</p>
			<p class="font" align="center">文化程度：
				<select name="education" size="1" style="width:100px;height:30px;">
					<option value="初中">初中</option>
					<option value="高中">高中</option>
					<option value="大专">大专</option>
					<option value="大学及以上">大学及以上</option>
				</select>
			</p>
			<p class="font" align="center">婚姻状况：
			<input style="width:200px;height:30px;" type="text" name="Mstatus"  maxlength="100">
			</p>
			<p class="font" align="center">家庭住址：
			<input style="width:200px;height:30px;" type="text" name="address"  maxlength="100">
			</p>
			<p class="font" align="center">联系方式：
			<input style="width:200px;height:30px;" type="text" name="phone"  maxlength="100">
			</p>
			<p class="font" align="center">身份证号：
			<input style="width:200px;height:30px;" type="text" name="identify"  maxlength="100">
			</p>
			<p align="center">
				<input type="submit" class="button1" value="保存修改">
				<input type="button"  onclick="location='EBISearch.jsp'" class="button2" value="返回查询">
			</p>
	</form>
</body>
</html>